var book={
    //增
    insert:'INSERT INTO `book` (`id`,`name`,`desc`,`price`,`sum`) VALUES(0,?,?,?,?)',
    //删
    delete: 'delete from book where id=?',
    //改
    update:'UPDATE book SET `name`=?,`desc`=?,`price`=?,`sum`=? WHERE `id`=? ',
    //查
    getAll: 'select * from book limit 0,20',
    findById: function (bookId) {
        return `select * from book where book_id=${bookId}`
    }
}

module.exports=book;